Returns or sets a value indicating the maximum number of rows to be returned from a query or processed in an action query.
Syntax
object.MaxRows [= value]
The MaxRows property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| value | A Long expression as described in Settings. |
Settings
The setting for value ranges from 0 to any number. If value is set to 0, no limit is placed on the number of rows returned (default). Setting value to a negative number is invalid and is automatically reset to 0.
Remarks
The MaxRows property limits the number of rows processed by the remote server. When MaxRows is set to a value greater than 0, only 'n' rows are processed. When executing a query that returns rows, it means that only the first 'n' rows are returned. When executing an action query, it means that only the first 'n' rows are updated, inserted or deleted.
This property is useful in situations where limited resources prohibit management of large numbers of result set rows. By setting MaxRows to 1 on an action query, you can be assured that no more than one row will be affected by the operation.